Oracle® Retail Integration Cloud Service

Release Notes

Release 19.0.000

 

F22273-01

January 2020

This document highlights the major changes for Release 19.0.000 of Oracle Retail Integration Cloud Service.

Overview

The Oracle Retail Integration Cloud Service (RICS) is comprised of the Oracle Retail Integration Suite of products that are cloud deployable for a customer's integration to Oracle Retail applications and the customer's on-premises or hybrid configurations of third-party applications.

The integration products supported are the same as the generally available on-premises versions of the Oracle Retail Integration Bus (RIB), the Oracle Retail Service Backbone (RSB), Oracle Retail Bulk Data Integration (BDI), Retail Financial Integration (RFI), and Universal service Mapper (USM).

The cloud-deployed versions of the integration products render some functionality and documentation inapplicable. For example, installation documentation is not provided in this release because those activities are handled by the cloud provider. In addition, customization tooling documentation is no longer available because those activities are no longer supported.

In a few documents, minor changes in configuration are noted. See the documentation library on docs.oracle.com for a list of documents associated with this release.

Note

The Oracle Retail Integration Cloud Service application is based on corresponding on-premises applications. References to the on-premises application names exist throughout the application and documents.

 

Note

The non-sequential version number of this Oracle Retail application is intentional.

 

Oracle Retail Cloud Services and Business Agility

Oracle Retail Integration Cloud Service is hosted in the Oracle Cloud with the security features inherent to Oracle technology and a robust data center classification, providing significant uptime. The Oracle Cloud team is responsible for installing, monitoring, patching, and upgrading retail software.

Included in the service is continuous technical support, access to software feature enhancements, hardware upgrades, and disaster recovery. The Cloud Service model helps to free customer IT resources from the need to perform these tasks, giving retailers greater business agility to respond to changing technologies and to perform more value-added tasks focused on business processes and innovation.

Oracle Retail Software Cloud Service is acquired exclusively through a subscription service (SaaS) model. This shifts funding from a capital investment in software to an operational expense. Subscription-based pricing for retail applications offers flexibility and cost effectiveness.

Client System Requirements

The following technology is supported:

Operating Systems

n        Microsoft Windows 7

n        Microsoft Windows 10

Note

Oracle Retail assumes that the retailer has ensured its operating system has been patched with all applicable Windows updates.

 

Browser Support

n        Mozilla Firefox ESR 68+

n        Microsoft Internet Explorer 11.0

n        Microsoft Edge 44+

n        Google Chrome (Desktop) 79+

n        Apple Safari 12+

Functional Enhancements

The following functional enhancements are included in this release:

BDI Supports Inbound Integration with External Systems

In the previous releases, BDI provided an integration infrastructure for outbound data from Oracle Retail applications to external systems/third party applications. In the current release, BDI supports inbound feeds from external systems to Oracle Retail applications. With this, external systems can send bulk data into the Oracle Retail echo system of products. This requires field implementation; however, the supporting artifacts such as table definitions, batch jobs, and process flow definitions to support external applications as a sender are available out of the box. For implementation details please refer to the Oracle Retail Bulk Data Integration Implementation Guide.

USM Functional Enhancements

Sr. No.

Change Description

1

Added Support for Multi Destination Allocation

2

Added Support for Multiple orders to multiple destination location in a single load/manifest

3

Added Support for Multiple orders to single destination location in a single load/manifest

4

Added Support for Multiple RTVs in single load/manifest

 

RIB Functional Enhancements

Sr. No.

Change Description

1

Added add XItem related message types to RIB and IGS:

n                Item Translation - Xitemtlcre/mod/del

n                Item Supplier Translation - Xitemsuptlcre/mod/del

n                Item Image Translation - Xitemimagetlcre/mod/del

n                Item HTS - Xitemhtscre/mod/del

n                Item HTS Assess - xitemhtsassesscre/mod/del

n                Item Ticket - xitemticketcre/mod/del

n                Item Expenses - xitemexpensescre/mod/del

n                Item Season - xitemseasoncre/mod/del

n                Item Upcharges - xitemchgcre/mod/del

2

Added Item Supplier operations to ItemManagement Web Service:

n                modifySupplier

n                deleteSupplier

n                modifySupplierCountry

n                deleteSupplierCountry

n                createSupplierCountryDim

n                modifySupplierCountryDim

n                deleteSupplierCountryDim

3

Added UDA-related operations to ItemManagement Web Service:

n                createUDA

n                modifyUDA

n                deleteUDA

4

Added new BDI flow interfaces for SIOCS. This flow is from third-party applications to SIOCS/EICS and does not involve other Oracle enterprise applications.

n                data flow of transfers

n                data flow of purchase orders

n                direct-to-store deliveries into SIOCS.

5

Added Daily & Weekly Demand Forecast Interface between RDF-RMS.

 

Technical Enhancements

The following technical enhancements described are included in this release:

BDI - Bulk API for Batch Job CRUD Operations

This release introduces new ReST Endpoints for Bulk Create/Update and Delete of Jobs in BDI/JOS Job admin applications. Existing end points can create/update/delete the individual jobs but the new endpoint allows bulk operations on jobs.

BDI - Support added for OAuth2 with IDCS

This release introduces new support for OAuth2(with IDCS) for BDI/JOS applications to improve the overall performance by avoiding multiple calls to the IDCS server. Although the recommended and default authorization mechanism is OAuth2, basicAuth is also supported to maintain backward compatibility. BDI Installers support OAuth2, and during installation, the installer collects additional information and configures the system options to support this change.

BDI services were OAuth2 enabled before so there are no changes to the service provider side. The only configuration changes required in BDI are for the service consumer side, which requires more information to talk to the IDCS OAuth2 Token Provider.

BDI - DB Schema Auto Migration

This release introduces a new database schema auto-migration feature with no user intervention. To run the migration scripts, it automatically migrates from the currently deployed application version to the application version that will be deployed to WebLogic. This support has only been added between the RICS versions (inclusive of 16.0.028 and 19.0.000).

BDI - Bulk Update for Schedule Status

A new ReST end point has been introduced in the scheduler application to allow the user to update the status of one or more schedules with a single ReSt request. Valid values for the schedule status update using the API are ACTIVE and DISABLED. The ReST end point returns the schedule level status for the status update operation.

RFI - ODI Replacement for CFIN Integration

In this release, the ODI tool has been replaced by PL/SQL packages to transform account entry data (from RMS/REIM) and invoice entry data (from REIM), making the data available as CFIN FBDI (File Based Data Integration) through the RFI database. CFIN ERP Integration web services are used to load and handle the data on the CFIN side.

A new set of adapters have been added in RFI UI to control these interfaces, and new logs have been added to troubleshoot the issues for these interfaces.

RFI - Domain Data Cross Reference UI Update

In this release, the Domain Data Cross Reference page in ORFI GUI has been renamed to "Manage DVM". The user can now update/delete the row except CommonID using the Update/Delete button. The user can also add a new row using the Add button. CommonID is an auto-generated sequential value.

RIB - Rest-app Type Support

In this release, the Rib installer is enhanced to install the following rib-applications:

n                rib-lgf can be installed as soap-app only

n                rib-rob can be installed as rest-app or javaee-app

n                rib-ocds can be installed as soap-app or javaee-app

Note

RIB no longer supports XPrcEvent flow from RMS to External. This flow is deprecated.

 

USM Support for Custom Projects

The USM allows the implementation of custom mapping to third party systems; however, the customer is responsible for the development of the new mapping projects. For this purpose, USM can be obtained from the client connector pack. USM with custom mapping must be installed on the PaaS/IaaS server managed by customers.

Client-Side Components for Retail Integration Cloud Service

The software products and components that are required on the client side for interaction with Retail Integration Cloud Service are delivered as a client connector pack.

A complete list of client-side downloadable products and components for Retail Integration Cloud Services is as follows:

Client Side Components

n                RIBCloudConnectorClientSideComponentsPak

n                RSBCloudConnectorClientSideComponentsPak

n                BDICloudConnectorClientSideComponentsPak

n                RFICloudConnectorClientSideComponentsPak

n                USMCloudConnectorClientSideComponentsPak

BDI

n                BdiFuncArtifact

n                BdiEdgeAppJobAdminPakForExternal

n                BdiCliJobExecutor

n                BdiCliTransmitter

n                BdiEdgeAppJobAdminPakForRFI

RIB

n                RIB functional artifact

n                Functional Artifact Generator

n                JAVA EE API stubs

n                PLSQL API stubs

n                Fileio

n                CSM

n                RetailPublicSecurityApi

n                RibKernel

n                RibPakForExt

n                RibPakForRMS

n                RibPakForRWMS

n                RibPakForRWMS2

n                RibPakForRWMS3

n                RibPakForRWMS4

RSB

n                RSE

n                Service Integration Pak for External applications

n                Service Integration Pak for IGS

n                J-SIT

n                Security Configuration sample scripts

RFI

n                BdiEdgeAppJobAdminPakForRFI

n                RetailFinancialIntegrationPakForRfi

USM

n                UniversalServiceMapperContainerPak

Support Considerations

For product support and logged defects, the product identifier for the Oracle Retail Integration Cloud Service is 13314. Each logged defect will be analyzed to determine the source of the reported issue.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle® Retail Integration Cloud Service Release Notes, Release 19.0

F22273-01

Copyright © 2020, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Value-Added Reseller (VAR) Language

Oracle Retail VAR Applications

The following restrictions and provisions only apply to the programs referred to in this section and licensed to you. You acknowledge that the programs may contain third party software (VAR applications) licensed to Oracle. Depending upon your product and its version number, the VAR applications may include:

(i) the MicroStrategy Components developed and licensed by MicroStrategy Services Corporation (MicroStrategy) of McLean, Virginia to Oracle and imbedded in the MicroStrategy for Oracle Retail Data Warehouse and MicroStrategy for Oracle Retail Planning & Optimization applications.

(ii) the Wavelink component developed and licensed by Wavelink Corporation (Wavelink) of Kirkland, Washington, to Oracle and imbedded in Oracle Retail Mobile Store Inventory Management.

(iii) the software component known as Access Via™ licensed by Access Via of Seattle, Washington, and imbedded in Oracle Retail Signs and Oracle Retail Labels and Tags.

(iv) the software component known as Adobe Flex™ licensed by Adobe Systems Incorporated of San Jose, California, and imbedded in Oracle Retail Promotion Planning & Optimization application.

You acknowledge and confirm that Oracle grants you use of only the object code of the VAR Applications. Oracle will not deliver source code to the VAR Applications to you. Notwithstanding any other term or condition of the agreement and this ordering document, you shall not cause or permit alteration of any VAR Applications. For purposes of this section, "alteration" refers to all alterations, translations, upgrades, enhancements, customizations or modifications of all or any portion of the VAR Applications including all reconfigurations, reassembly or reverse assembly, re-engineering or reverse engineering and recompilations or reverse compilations of the VAR Applications or any derivatives of the VAR Applications. You acknowledge that it shall be a breach of the agreement to utilize the relationship, and/or confidential information of the VAR Applications for purposes of competitive discovery.

The VAR Applications contain trade secrets of Oracle and Oracle's licensors and Customer shall not attempt, cause, or permit the alteration, decompilation, reverse engineering, disassembly or other reduction of the VAR Applications to a human perceivable form. Oracle reserves the right to replace, with functional equivalent software, any of the VAR Applications in future releases of the applicable program.

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.